CREATE TABLE [dbo].[CertificationProgramCertificationModule]
(
[CertificationProgramKey] [uniqueidentifier] NOT NULL,
[CertificationModuleKey] [uniqueidentifier] NOT NULL,
[CertificationProgramCertificationModuleKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_CertificationProgramCertificationModule_CertificationProgramCertificationModuleKey] DEFAULT (newid())
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[CertificationProgramCertificationModule] ADD CONSTRAINT [PK_CertificationProgramCertificationModule] PRIMARY KEY CLUSTERED ([CertificationProgramCertificationModuleKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationProgramCertificationModule_CertificationModuleKey] ON [dbo].[CertificationProgramCertificationModule] ([CertificationModuleKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationProgramCertificationModule_CertificationProgramKey] ON [dbo].[CertificationProgramCertificationModule] ([CertificationProgramKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CertificationProgramCertificationModule] ADD CONSTRAINT [FK_CertificationProgramCertificationModule_CertificationModule] FOREIGN KEY ([CertificationModuleKey]) REFERENCES [dbo].[CertificationModule] ([CertificationModuleKey])
GO
ALTER TABLE [dbo].[CertificationProgramCertificationModule] ADD CONSTRAINT [FK_CertificationProgramCertificationModule_CertificationProgram] FOREIGN KEY ([CertificationProgramKey]) REFERENCES [dbo].[CertificationProgram] ([CertificationProgramKey])
GO